package model.agent.mapper;



import model.agent.entity.Personnel;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * Created by Administrator on 2019/6/24.
 */
@Mapper
public interface PersonnelMapper {
    @Select("select * from personnel where id = #{id}")
    List<Personnel> find(String id);
    @Insert("insert into personnel values(#{id},#{time},#{title},#{workconet},#{level},#{c_id},#{community},#{pictruce_id},#{self_resume})")
    void save(Personnel personnel);
    @Select("select * from  personnel where name like concat('%',#{name},'%')")
    List<Personnel> findall(String name);
    @Delete("delete from  personnel where name=#{name}")
    void  del(String name);
    @Update("update personnel set name=#{name} where id = #{id}")
    void  update(@Param("id") String id, @Param("name") String name);

}
